/* Get Tablespace Size information*/

SELECT a.TABLESPACE_NAME,
	(a.BYTES/1024)/1024 Mbytes_used,
	(b.BYTES/1024)/1024 Mbytes_free,
	b.largest,
	Round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used
FROM
	(
	SELECT TABLESPACE_NAME, Sum(BYTES) BYTES
	FROM dba_data_files
	GROUP BY TABLESPACE_NAME
	)a,
	(
	SELECT TABLESPACE_NAME,
	Sum(BYTES) BYTES ,
	Max(BYTES) largest
	FROM dba_free_space
	GROUP BY TABLESPACE_NAME
	)b
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME
ORDER 	by a.TABLESPACE_NAME